Construire un mini-entrepôt de données environnementales au format i2b2
06/01/2019
Introduction
Description des données :
## nom codeCommune nomCommune ## Length:9572 Length:9572 Length:9572 ## Class :character Class :character Class :character ## Mode :character Mode :character Mode :character ## cp designationAPE designationEPRTR ## Length:9572 Length:9572 Length:9572 ## Class :character Class :character Class :character ## Mode :character Mode :character Mode :character
Liste des Etablissements polluants selon GeoRisque
localisation etablissement
## Identifiant Nom Etablissement Numéro Siret ## Length:14954 Length:14954 Length:14954 ## Class :character Class :character Class :character ## Mode :character Mode :character Mode :character ## Adresse Code Postal Commune ## Length:14954 Length:14954 Length:14954 ## Class :character Class :character Class :character ## Mode :character Mode :character Mode :character ## Departement Region coordonnées_x ## Length:14954 Length:14954 Length:14954 ## Class :character Class :character Class :character ## Mode :character Mode :character Mode :character ## coordonnées_y Code APE Libellé APE ## Length:14954 Length:14954 Length:14954 ## Class :character Class :character Class :character ## Mode :character Mode :character Mode :character ## Code Eprtr Libelle Eprtr coordonnees ## Length:14954 Length:14954 Length:14954 ## Class :character Class :character Class :character ## Mode :character Mode :character Mode :character
Liste des Etablissements avec leur localisation
potentiel Radon
## nom_comm nom_dept insee_com classe_potentiel ## Length:36104 Length:36104 Length:36104 Min. :1.000 ## Class :character Class :character Class :character 1st Qu.:1.000 ## Mode :character Mode :character Mode :character Median :1.000 ## Mean :1.449 ## 3rd Qu.:2.000 ## Max. :3.000 ## NA's :2 ## reg ## Length:36104 ## Class :character ## Mode :character ## ## ## ##
Potentiel Radon
Schema Etoile
Schema Etoile
** Schema Etoile **
Tables Construites
## nom_comm nom_dept insee_com classe_potentiel ## Length:10429 Length:10429 Length:10429 Min. :1.000 ## Class :character Class :character Class :character 1st Qu.:1.000 ## Mode :character Mode :character Mode :character Median :1.000 ## Mean :1.515 ## 3rd Qu.:2.000 ## Max. :3.000 ## NA's :513 ## reg Nom_etablissement Identifiant ## Length:10429 Length:10429 Length:10429 ## Class :character Class :character Class :character ## Mode :character Mode :character Mode :character ## ## ## ## ## Num_Siret Adresse Code Postal ## Length:10429 Length:10429 Length:10429 ## Class :character Class :character Class :character ## Mode :character Mode :character Mode :character ## ## ## ## ## Region coordonnées_x coordonnées_y ## Length:10429 Length:10429 Length:10429 ## Class :character Class :character Class :character ## Mode :character Mode :character Mode :character ## ## ## ## ## CODE_APE Libelle_APE CODE_Eprtr ## Length:10429 Length:10429 Length:10429 ## Class :character Class :character Class :character ## Mode :character Mode :character Mode :character ## ## ## ## ## Libelle Eprtr coordonnees lng lat ## Length:10429 Length:10429 Min. :-12.78 Min. :-4.927 ## Class :character Class :character 1st Qu.: 45.40 1st Qu.: 0.402 ## Mode :character Mode :character Median : 47.44 Median : 2.517 ## Mean : 46.96 Mean : 2.534 ## 3rd Qu.: 48.85 3rd Qu.: 4.839 ## Max. : 51.05 Max. :45.257 ##
** Entrepot de données **
Carte Interactives
Carte Maladie
Carte Potentiel Radon
Carte Etablissements
Analyses de données
Histogramme d'analyse
Analyses de données
Test d'autocorrelation Spatial
Voisinage de type QUEEN :
Voisinage de type QUEEN
Test de Morane
## ## Moran I test under normality ## ## data: ratioEvenement$ratio ## weights: matrice_conguiteQ ## ## Moran I statistic standard deviate = 0.14069, p-value = 0.8881 ## alternative hypothesis: two.sided ## sample estimates: ## Moran I statistic Expectation Variance ## -0.001007117 -0.010526316 0.004578167
Test de Morane
Histogramme du Bootstrap
Histogramme de Bootstrap
Tests de geary
## ## Geary C test under randomisation ## ## data: ratioEvenement$ratio ## weights: matrice_conguiteQ ## ## Geary C statistic standard deviate = -0.58119, p-value = 0.5611 ## alternative hypothesis: two.sided ## sample estimates: ## Geary C statistic Expectation Variance ## 1.041589500 1.000000000 0.005120805
Test de Geary
Autocorrelogramme
Autocorrelogramme
Test de Stone :
Exemple pour Paris
## Stone's Test for raised incidence around locations ## ## Type of boots.: parametric ## Model used when sampling: Poisson ## Number of simulations: 99 ## Statistic: 1 ## p-value : 1
Test de Stone
## PhantomJS not found. You can install it with webshot::install_phantomjs(). If it is installed, please make sure the phantomjs executable can be found via the PATH variable.
Shiny applications not supported in static R Markdown documents
Merci
Merci de votre Attention